MacWorld 1998 January

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1998 January / Macworld (1998-01).dmg / FileMaker Pro 4 / Full FM4 Templates / Business / Inventory System / Product Inventory (.txt) next >

Wrap

FileMaker Pro Database | 1997-09-14 | 129.0 KB | 808 lines | [FMP3/FMP3]

HBAM2016AUG95 Pro 3.0 HBAM3016AUG95 HP DeskJet 540 Printer Pro 2.0 - 2.1F! Pro 3.0 FileMaker Pro 3.0 Folder CATEGORY CREATED BY DATE CREATED DATE MODIFIED INITIAL INVENTORY LEVEL OPEN TO BUY PEAK LEVEL PICTURE PRODUCT DESCRIPTION PRODUCT ID PRODUCT NAME QUANTITY ON HAND QUANTITY SOLD REORDER LEVEL REORDER QUANTITY RETAIL SUPPLIER ADDRESS SUPPLIER CITY SUPPLIER COMPANY SUPPLIER COUNTRY SUPPLIER FAX SUPPLIER ID SUPPLIER NAME SUPPLIER PHONE SUPPLIER STATE SUPPLIER ZIP CODE UNIT WEIGHT Product IDB Date CreatedB Date ModifiedB Product NameB Product DescriptionB Category search for all records whose Reorder Quantity is greater than zero, and then print a purchase order for each of those records. Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 7/29/975 Description Use this database file to track product inventory. How to use this solution Set the Initial Inventory Level--the quantity you have in stock. FileMaker Pro will automatically calculate Quantity On Hand by subtracting quantities sold in the Product Sales file.You can also set the Reorder Level, the minimum inventory you want to maintain, and the Peak Level, the maximum inventory you want to maintain. FileMaker Pro automatically calculates the Open to Buy, the difference betwee n the Quantity On Hand and the Peak Level. How to customize this solution You can create lookups in this file to your own supplier file. You can create a report and a script that will automatically generate purchase orders for products whose inventory level (Quantity On Hand) falls below the Reorder Level. FileMaker Pro calculates the Reorder Quantity as the difference between the Reorder Level and the Quantity On Hand. The script you create should search for all records whose Reorder Qu CostB RetailB PictureB InfoB Created ByB Quantity On HandB Reorder LevelB 50XgThe Reorder Level must be less than the Peak Level. Enter the minimum stock level you want to maintain. Z > 0) Initial Inventory LevelB X?The Initial Inventory Level must be greater than or equal to 0. [ >= 0) Quantity SoldB Supplier IDB Supplier NameB Supplier AddressB Supplier CityB Supplier StateB Supplier ZIP CodeB Supplier CountryB Peak LevelB 100XwThe Peak Level must be greater than the Reorder Level. Enter the quantity at which you want to maintain your inventory. Open to BuyB Unit WeightB Supplier PhoneB Supplier FaxB Supplier CompanyB Reorder QuantityB Form View - Product A List View Product Inventory Information Report Menu Form View - Supplier Form View - ProductB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Category Product ID Enter data for Products Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Inventory Sales File... Initial Level Line Items File... Supplier Category Product ID Enter data for Products Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Inventory Sales File... Initial Level Line Items File... Supplier Product Quantity Sold On Hand Reorder Level Peak Level Open to Buy Inventory Pricing Retail Description Unit Weight Picture Product InventoryB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter On Handc Retaild Coste Categoryf Nameg IDh+Click to see more information for a Products Infot Closeu View As Formv View As Listw Reportsx Recordy Delete Recordz Record{ Your Own Button| Your Own Button InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Product Inventory Close Product Inventory Close View As View As Reports Your Own Button Product ID Product Name On Hand Reorder Level Peak Level $Product Inventory Report by Category Page ## Open to Buy Report MenuB P0Information about the Product Inventory solutionQ Info for this SolutionS InfoT CloseU View As FormV View As ListW ReportsX Your Own Button View As FormV View As ListW ReportsX Your Own Button Your Own ReportI Your Own ReportJ Your Own ReportK Product InventoryL>Click on any of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button on any of these buttons to preview the respective reportM Select a reportN InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button Form View - SupplierB Yesfter Noarter Yesfter Noarter Yesfter Noarter InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Product ID v Enter data for Product Suppliers Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Inventory Sales File... Line Items File... Supplier Product Company Address City / State / ZIP Code Country duct Suppliers Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button Product Inventory Sales File... Line Items File... Supplier Product Company Address City / State / ZIP Code Country Phone Sort by Product Name Product Inventory Report Sort by Category Open Script InfoO CloseP View As FormQ View As ListR ReportsS Your Own Button Open Product Sales File Open Product Line Items File Dial Phone wwwwww Helvetica Geneva Times Times New Roman Arial MS Sans Serif Fixedsys wwwwww ffffff UUUUUU DDDDDD )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) Open Product Sales File Open Product Line Items File Sort by Product ID Sort by Product Name Sort by Category Product Inventory Report Open Script Dial Phone Sort by Product ID Sort by Product Name Product Inventory Report Sort by Category Open Script """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw CNAME FPTHACHARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Product Sales.fp3 NAMEA Product Sales.fp3 RPTHA Product Sales.fp3 SRPTA prod_sal.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ HNAME FPTHAHHARDDISK:CONSULT:ClarisII:KenMahlr:inbox:95-10-04:Product Line Items.fp3 NAMEA Product Line Items.fp3 RPTHA Product Line Items.fp3 SRPTA prod_itm.fp3 WSPCA-C:\CONSULT\ClarisII\KenMahlr\inbox\95-10-04\ (LIST LISTA-Coastal Posters Nature Posters Outdoor Gear VDEFA( Category List FMRLA Product Line Items ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 3333ff 333333 wwwwww UUUUUU DDDDDD """""" UUUUUU wwwwww (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,* !$&(265389,#!$$ '275? " $$*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+,)+" &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!PQ 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%&' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGCA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9< 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,027CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 876=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*, 169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,*3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7) !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,M4%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww wwwwww ffffff UUUUUU DDDDDD 333333 wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" "%UR UD33D #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff UUUUUU DDDDDD B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 AD@D@ AD@D@ AD@BL 44444 CCCCC 44444 CCCCC $42" @@BA@ bRBBP0 ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" Helvetica Geneva Times Times New Roman Arial MS Sans Serif Fixedsys WCWantity is greater than zero, and then print a purchase order for each of those records.